create database school;

use school;

create table student (
RollNum int,
Name char(10),
Grade char(10),
Age int
);

SELECT RollNum ,Name ,Grade ,Age FROM student

insert into student (RollNum, Name, Grade, Age)	values (1,'ABC','Nursary',4);
			--We are inserting data row wise.

SELECT RollNum ,Name ,Grade ,Age FROM student

insert into student (RollNum, Name, Grade, Age) values (2,'BCD','UKG',6);
			--We are inserting data row wise.

SELECT RollNum ,Name ,Grade ,Age FROM student

update student set Name = 'DEF' where Rollnum = 2

SELECT RollNum ,Name ,Grade ,Age FROM student

delete from  student where Rollnum  = 1
--Deletion happens row wise.

SELECT RollNum ,Name ,Grade ,Age FROM student